SYLLABUS

UNIT-I

Basic Concepts – Data, Information, Records and files. Traditional file –based Systems-File Based Approach-Limitations of File Based Approach, Database Approach-Characteristics of Database Approach, advantages and disadvantages of database system, components of database system, Database Management System (DBMS), Components of DBMS Environment, DBMS Functions and Components, DBMS users, Advantages and Disadvantages of DBMS, DBMS languages. Roles in the Database Environment - Data and Database Administrator, Database Designers, Applications Developers and Users .

UNIT-II

Database System Architecture – Three Levels of Architecture, External, Conceptual and Internal Levels, Schemas, Mappings and Instances . Data Independence – Logical and Physical Data Independence . Classification of Database Management System, Centralized and Client Server architecture to DBMS . Data Models: Records- based Data Models, Object-based Data Models, Physical Data Models and Conceptual Modeling.

UNIT-III

Entity-Relationship Model – Entity Types, Entity Sets, Attributes Relationship Types, Relationship Instances and ER Diagrams, abstraction and integration. Basic Concepts of Hierarchical and Network Data Model, Relational Data Model:-Brief History, Relational Model Terminology-Relational Data Structure, Database Relations, Properties of Relations, Keys, Domains, Integrity Constraints over Relations,

UNIT-IV

Relational algebra, Relational calculus, Relational database design: Functional dependencies, Modification anomalies, Ist to 3rd NFs, BCNF, 4th and 5th NFs, computing closures of set FDs, SQL: Data types, Basic Queries in SQL, Insert, Delete and Update Statements, Views, Query processing: General strategies of query processing, query optimization, query processor, concept of security, concurrency and recovery.